/*
 Navicat Premium Data Transfer

 Source Server         : learn
 Source Server Type    : MySQL
 Source Server Version : 80019
 Source Host           : localhost:3306
 Source Schema         : caiwu

 Target Server Type    : MySQL
 Target Server Version : 80019
 File Encoding         : 65001

 Date: 16/05/2020 10:40:19
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for asset
-- ----------------------------
DROP TABLE IF EXISTS `asset`;
CREATE TABLE `asset` (
  `assetid` int NOT NULL AUTO_INCREMENT,
  `assetamount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `fuzhai` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `equity` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`assetid`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of asset
-- ----------------------------
BEGIN;
INSERT INTO `asset` VALUES (1, '1000012', '11111121', '3333312', '201901');
INSERT INTO `asset` VALUES (3, '1500021', '1124124', '1212122', '201902');
INSERT INTO `asset` VALUES (4, '1002341', '333334', '5555521', '201903');
INSERT INTO `asset` VALUES (5, '1012122', '444441', '5555511', '201904');
INSERT INTO `asset` VALUES (6, '1022233', '5555531', '5555511', '201905');
INSERT INTO `asset` VALUES (7, '1034144', '6666612', '5555511', '201906');
INSERT INTO `asset` VALUES (8, '1423155', '11231232', '5555511', '201907');
INSERT INTO `asset` VALUES (9, '1233112', '8888812', '5555511', '201908');
INSERT INTO `asset` VALUES (10, '1232133', '9999922', '5555511', '201909');
INSERT INTO `asset` VALUES (11, '1034133', '1000011', '5555511', '201910');
INSERT INTO `asset` VALUES (12, '1509144', '1000011', '5555511', '201911');
INSERT INTO `asset` VALUES (13, '1420144', '1124124', '5555511', '201912');
INSERT INTO `asset` VALUES (14, '500022', '1124124', '4444411', '202001');
INSERT INTO `asset` VALUES (15, '1000022', '1124124', '5555533', '202002');
INSERT INTO `asset` VALUES (16, '1000011', '1200012', '4411221', '202003');
INSERT INTO `asset` VALUES (17, '1000044', '1124124', '3333316', '202004');
INSERT INTO `asset` VALUES (18, '1023221', '3425512', '5555511', '202005');
INSERT INTO `asset` VALUES (19, '1000022', '222000', '5555511', '201801');
INSERT INTO `asset` VALUES (20, '15000', '1124124', '5555511', '201802');
INSERT INTO `asset` VALUES (21, '10000', '1424124', '5555511', '201803');
INSERT INTO `asset` VALUES (22, '10000', '1124124', '5555511', '201804');
INSERT INTO `asset` VALUES (23, '10000', '1124124', '5555511', '201805');
INSERT INTO `asset` VALUES (24, '10000', '1324124', '5555511', '201806');
INSERT INTO `asset` VALUES (25, '10000', '1124124', '5555511', '201807');
INSERT INTO `asset` VALUES (26, '10000', '1124124', '5555511', '201808');
INSERT INTO `asset` VALUES (27, '10000', '1124124', '5555511', '201809');
INSERT INTO `asset` VALUES (28, '10000', '1000021', '5555511', '201810');
INSERT INTO `asset` VALUES (29, '10000', '1124124', '5555511', '201811');
INSERT INTO `asset` VALUES (30, '10000', '5555512', '5555511', '201812');
COMMIT;

-- ----------------------------
-- Table structure for earn
-- ----------------------------
DROP TABLE IF EXISTS `earn`;
CREATE TABLE `earn` (
  `incomeid` int NOT NULL AUTO_INCREMENT,
  `income` varchar(255) DEFAULT NULL,
  `chengben` varchar(255) DEFAULT NULL,
  `profits` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`incomeid`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of earn
-- ----------------------------
BEGIN;
INSERT INTO `earn` VALUES (1, '1022221', '102000', '123334', '201901');
INSERT INTO `earn` VALUES (2, '1222221', '112000', '153334', '201902');
INSERT INTO `earn` VALUES (3, '1322221', '142000', '143334', '201903');
INSERT INTO `earn` VALUES (4, '1422221', '131023', '133334', '201904');
INSERT INTO `earn` VALUES (5, '1322221', '151000', '103334', '201905');
INSERT INTO `earn` VALUES (6, '1422221', '110000', '113334', '201906');
INSERT INTO `earn` VALUES (7, '1522321', '123000', '143334', '201907');
INSERT INTO `earn` VALUES (8, '1722232', '140000', '153334', '201908');
INSERT INTO `earn` VALUES (9, '1622221', '155000', '163334', '201909');
INSERT INTO `earn` VALUES (10, '1522221', '100000', '177334', '201910');
INSERT INTO `earn` VALUES (11, '1622221', '90000', '188334', '201911');
INSERT INTO `earn` VALUES (12, '1762221', '100000', '180334', '201912');
INSERT INTO `earn` VALUES (15, '1230441', '100000', '123334', '201801');
INSERT INTO `earn` VALUES (16, '1230441', '100000', '123334', '201802');
INSERT INTO `earn` VALUES (17, '1230441', '100000', '123334', '201803');
INSERT INTO `earn` VALUES (18, '1230441', '100000', '123334', '201804');
INSERT INTO `earn` VALUES (19, '1230441', '100000', '123334', '201805');
INSERT INTO `earn` VALUES (20, '1230441', '100000', '123334', '201806');
INSERT INTO `earn` VALUES (21, '1230441', '100000', '123334', '201807');
INSERT INTO `earn` VALUES (22, '1230441', '100000', '123334', '201808');
INSERT INTO `earn` VALUES (23, '1230441', '100000', '123334', '201809');
INSERT INTO `earn` VALUES (24, '1230441', '100000', '123334', '201810');
INSERT INTO `earn` VALUES (25, '1230441', '100000', '123334', '201811');
INSERT INTO `earn` VALUES (26, '1230441', '100000', '123334', '201812');
INSERT INTO `earn` VALUES (27, '1230441', '111000', '113334', '202001');
INSERT INTO `earn` VALUES (28, '1230441', '100000', '123334', '202002');
INSERT INTO `earn` VALUES (29, '1230441', '100000', '123334', '202003');
INSERT INTO `earn` VALUES (30, '1230441', '100000', '123334', '202004');
INSERT INTO `earn` VALUES (31, '1111111', '123000', '142222', '202005');
INSERT INTO `earn` VALUES (32, '2222222', '140200', '152222', '202006');
COMMIT;

-- ----------------------------
-- Table structure for prdcount
-- ----------------------------
DROP TABLE IF EXISTS `prdcount`;
CREATE TABLE `prdcount` (
  `account_id` int NOT NULL AUTO_INCREMENT,
  `saleaccount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `yield` varchar(255) DEFAULT NULL,
  `stock` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of prdcount
-- ----------------------------
BEGIN;
INSERT INTO `prdcount` VALUES (1, '10000', '20000', '10000', '201901');
INSERT INTO `prdcount` VALUES (3, '15000', '20000', '15000', '201902');
INSERT INTO `prdcount` VALUES (4, '10023', '10000', '15000', '201903');
INSERT INTO `prdcount` VALUES (5, '10121', '20000', '25000', '201904');
INSERT INTO `prdcount` VALUES (6, '10222', '20123', '35110', '201905');
INSERT INTO `prdcount` VALUES (7, '10341', '20123', '45023', '201906');
INSERT INTO `prdcount` VALUES (8, '14231', '20444', '55000', '201907');
INSERT INTO `prdcount` VALUES (9, '12331', '20000', '65000', '201908');
INSERT INTO `prdcount` VALUES (10, '12321', '10000', '55044', '201909');
INSERT INTO `prdcount` VALUES (11, '10341', '10000', '55000', '201910');
INSERT INTO `prdcount` VALUES (12, '15091', '10000', '55233', '201911');
INSERT INTO `prdcount` VALUES (13, '14201', '10000', '55230', '201912');
INSERT INTO `prdcount` VALUES (14, '5000', '10000', '5000', '202001');
INSERT INTO `prdcount` VALUES (15, '10000', '11000', '1000', '202002');
INSERT INTO `prdcount` VALUES (16, '10000', '12000', '2000', '202003');
INSERT INTO `prdcount` VALUES (17, '10000', '15300', '5300', '202004');
INSERT INTO `prdcount` VALUES (18, '10232', '14235', '4002', '202005');
INSERT INTO `prdcount` VALUES (19, '10000', '20000', '10000', '201801');
INSERT INTO `prdcount` VALUES (20, '15000', '20000', '15000', '201802');
INSERT INTO `prdcount` VALUES (21, '10000', '10000', '15000', '201803');
INSERT INTO `prdcount` VALUES (22, '10000', '20000', '25000', '201804');
INSERT INTO `prdcount` VALUES (23, '10000', '20000', '35000', '201805');
INSERT INTO `prdcount` VALUES (24, '10000', '20000', '45000', '201806');
INSERT INTO `prdcount` VALUES (25, '10000', '20000', '55000', '201807');
INSERT INTO `prdcount` VALUES (26, '10000', '20000', '65000', '201808');
INSERT INTO `prdcount` VALUES (27, '10000', '10000', '55000', '201809');
INSERT INTO `prdcount` VALUES (28, '10000', '10000', '55000', '201810');
INSERT INTO `prdcount` VALUES (29, '10000', '10000', '55000', '201811');
INSERT INTO `prdcount` VALUES (30, '10000', '10000', '55000', '201812');
INSERT INTO `prdcount` VALUES (31, '10000', '13000', '55000', '201712');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `userid` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, 'admin111', 'admin');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
